php Programming Glossary: alias2
MySQL: How to COUNT the number of rows returned by a Complicated Query http://stackoverflow.com/questions/7148713/mysql-how-to-count-the-number-of-rows-returned-by-a-complicated-query the NUMBER OF ROWS returned by this query SELECT Alias1 . Alias2 . FROM Table1 AS Alias1 LEFT JOIN Table2 AS Alias2 USING Col1.. . Alias2 . FROM Table1 AS Alias1 LEFT JOIN Table2 AS Alias2 USING Col1 WHERE Alias1.Col1 'blah1' AND Alias1.Col2 LIKE 'blah2'.. OR Alias1.Col3 LIKE 'blah4' AND Alias1.Col4 'blah5' AND Alias2.Col7 LIKE 'blah6' ORDER BY Alias1.Col6 DESC LIMIT 50 UNION SELECT..
|
