¡@

Home 

php Programming Glossary: alias1

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

just get the NUMBER OF ROWS returned by this query SELECT Alias1 . Alias2 . FROM Table1 AS Alias1 LEFT JOIN Table2 AS Alias2.. by this query SELECT Alias1 . Alias2 . FROM Table1 AS Alias1 LEFT JOIN Table2 AS Alias2 USING Col1 WHERE Alias1.Col1 'blah1'.. AS Alias1 LEFT JOIN Table2 AS Alias2 USING Col1 WHERE Alias1.Col1 'blah1' AND Alias1.Col2 LIKE 'blah2' AND Alias1.Col3 LIKE..