Search code examples
mysqlsqlsqlyog

Beginner - Query a value in a column that's labeled as text

I have a database with one column which is labeled as text. I want to query just a single value from that text column. However, when I write the code in SQLyog, text turns into TEXT, which is apparently related to character types in mysql. I just want to know how I can query the table for a value that is in a column labeled text.

SELECT id, keyword_netword_id, TEXT, match_type, create_date FROM keywords WHERE TEXT LIKE '%medicare supplemental insurance%';

I'm not typing in text as uppercase, it's just that SQLyog automatically turns into upper case.

Solution

  • simple:

    SELECT `id`, `keyword_netword_id`, `text`, `match_type`, `create_date` FROM `keywords` WHERE `text` LIKE '%medicare supplemental insurance%';