[SQL] return records with more than one occurrences

how would the SELECT to return only records with more than one occurrences of id_table1? example: -- Table1 -- id -- - 1 2 -- Table2 id --- | id_table1 | name -- 4 | - 1 -- | Tom 5 |

[SQL] pattern matching with dates?

This dubious query worked well previously: select * from db_log where log_date LIKE '2011-01-%'; (currently works on bluehost.com where they run 8.1.22) Can someone offer a (preferably ANSI compliant) way to do this on 8.4.5? I realize that >= and so on work well (which may explain why the docs a