od as LIKE OR LIKE OR ...
> results-wise. I don't know if it's faster/less intensive or not though.
> You'd have to do some tests.
>
> Also, comparisons like "=" should (if I recall) be faster than LIKE
> comparisons. So if you really meant to use "=
e or not though.
You'd have to do some tests.
Also, comparisons like "=" should (if I recall) be faster than LIKE
comparisons. So if you really meant to use "=", do that instead.
Let me know if any of that's unclear. I know I get some kooky ideas
sometimes. Also, an
Got if figured out, needed a sub-select type of query:
mysql> SELECT *
-> FROM ( SELECT * FROM `orders`
-> WHERE `group` = "groupname" )
-> AS orders UNION SELECT * FROM `orders`
-> WHERE `ordernum` LIKE "35132"
-> OR `price` LIKE "35132"
-> OR `partnum` LIKE "35132"
