Jump to content

Selecting all from a row if variable is undefined?


TJMAudio

Recommended Posts

Say I have an INT row that contains numbers 0 through 11.  If the user does not define a number, I want it to pull from the row, no matter what it contains.  Sorry if I am explaining this unclearly.  Anyways, would I just do it like this:

 

SELECT * FROM table WHERE $variable LIKE '%'

 

Or is there some other way of doing it?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.