var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query using LIKE
What is the query syntax for finding a word/string within a longer word/string?
For example, if the above question was the value of FIELD1 in TABLE1 of DATABASE1, what would the query look like if I wanted to search by the word "syntax" and have the results return FIELD1 as a match?
is this a trick question? wouldn't ordinary LIKE syntax do it?
select FIELD1 from TABLE1
where FIELD1 like '%syntax%'
I wasn't sure. I saw a LIKE statement, but then I also saw things like
.... Where MATCH (FIELD1) Against (STRING) ...
and something about specifying a full text search key. Do I need to do those things, too?
If I use the ...Where FIELD1 like '%syntax%' ... does it matter how many characters are in the field I am searching?
LIKE should suffice
i know in oracle you cannot search a LONG datatype with LIKE, but there appears to be no such restriction in mysql
MATCH (which i've never used) returns relevancy -- check 188.8.131.52 String Comparison Functions