[RESOLVED] Multiple = or LIKE in a same query?

Master_Zen

I have the following mySQL query:

SELECT * FROM entry WHERE TEXT LIKE '%search%' AND TITLE NOT LIKE '%search%' AND COMPANY NOT LIKE '%search%'

Is it possible to reduce this query to something like

SELECT * FROM entry WHERE TEXT LIKE '%search' AND TITLE , COMPANY NOT LIKE '%search%'

(obviously that is incorrect code, just wanted to illustrate what I want)

also, is it possible to add multiple LIKE statements? something WHERE TEXT LIKE '%search%' OR '%search2%' OR '%search3%'

Thanks 😃

bradgrafelman

Master Zen wrote:
Is it possible to reduce this query

AFAIK, no, you have to write out the field names and LIKE conditions individually.

Master Zen wrote:
is it possible to add multiple LIKE statements?

Definitely. Once again, you have to name the column each time.

Master_Zen

Ok, thanks. Guess there's no easy way out ain't there?

Piranha

It's all about how you think. Basically each statement returns TRUE or FALSE for each row. In your reduced code you have these statements:

TEXT LIKE '%search'
TITLE
COMPANY NOT LIKE '%search%'

The first and last will return true or false. The one in the middle won't, meaning that it is not a complete statement. Same in your last query:

TEXT LIKE '%search%'
'%search2%'
'%search3%'

The first will return a valid result, the others won't. But there is an easy way out. Just type the whole statements.

What I don't understand is why people want to do this. It probably takes longer to first search, make a good question and read answers than the time saved by just typing the whole queries.