USE yourheart SHOW TABLES SELECT * FROM net_type SELECT * FROM net_type WHERE n_type='mysql' SELECT * FROM net_type WHERE n_type LIKE '%mysql%'