] Re: mysql statement [SOLVED]
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
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
- OR
Message -
From: Jas [EMAIL PROTECTED]
To: php-db@lists.php.net
Date: Wed, 26 Sep 2007 12:08:53 -0600
Subject: [PHP-DB] Re: mysql statement [SOLVED]
Got if figured out, needed a sub-select type of query:
mysql SELECT *
- FROM ( SELECT * FROM `orders`
- WHERE `group` = groupname