A:
select * from #temp
where product_id='1234'
and `desc` not like '%[%'
and `desc` not like '%[%'
and `desc` not like '%[%'
should be
select * from #temp
where product_id='1234'
and `desc` not like '%[%'
and `desc` not like '%[%'
and `desc` not like '%[%'
and `desc` not like '%[%'
and `desc` not like '%[%'
and `desc` not like '%[%'
and `desc` not like '%[%'
The code above will get you products that are in the description that do not contain a square bracket [ or ].
Also, you can use:
where product_id='1234'
and `desc` like '%[%'
and `desc` like '%[%'
and `desc` like '%[%'
and `desc` like '%[%'
and `desc` like '%[%'
and `desc` like '%[%'
and `desc` like '%[%'
and `desc` like '%[%'
Or you can get rid of the product_id completely.
In your other question, you had some other problems. You can't use a like in an or. You are comparing to a string. So you need to use
Oral toxicity of calcium acetate in rats.
Rats were treated daily for 3 weeks with 0.17, 0.6 or 2. be359ba680
Related links:
Comments