If you want all records, remove the where clause. select * from mytable Jim -------Original Message------- From: Edward Peloke Date: Wednesday, January 08, 2003 02:03:04 PM To: php-db@lists.php.net Subject: mysql wildcard I have an query: select * from offtime where type='$type' then I just pass the type variable to the page. Is there a wildcard in mysql like there is in sqlserver that I can use to grab all the records? such as select * from offtime where type='%' would grab all. Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php .
