Value Comparison

nextgengames

I have a small problem right now not sure how to get it fixed. I have two tables articles and games, articles stores games like this "|23|56|2|" and the games is ID so "23"

So far Im doing to get the games linked to articles this month

SELECT DISTINCT `game` FROM `vg_articles` WHERE `event` = '8'''

Then doing a loop to go find the game name for the list, The SQL is like this

SELECT * from 'game' WHERE `id` = '%|23|%'

It seems to keep coming up blank even though the game exists.

Any Help Appreciated.

Plasma

You need to use the LIKE keyword when you want to do a wildcard comparison:

SELECT * from 'game' WHERE id LIKE '%|23|%'

Also, your going about this the wrong way.

You should have (possibly another, or fix your design) table which maps games to articles (or whatever).

Doing it the above way is inefficient and 'dirty'.

nextgengames

Yeah I know the table setup sucks arse but i didnt do it 😉 Ive tried LIKE as well but get SQL errors or Blank results. I tried this

SELECT *
FROM vg_games
WHERE id LIKE '%|23|%'
ORDER BY name ASC
LIMIT 0 , 30

I get a empty result even though 23 on its own works

laserlight

I know the table setup sucks arse but i didnt do it

1. Backup the database.
2. Normalise the database. [man]explode/man in PHP could prove useful.
3. Torture and/or kill the programmer that designed the database and caused you such pain.

I suggest you follow the order in case anything goes wrong. Step 3 is optional.

nextgengames

I really wish I had that kind of time, The script im writing has to be done today. The database is pretty big as well

laserlight

As far as I can tell:

SELECT *
	FROM `vg_games`
	WHERE `id` LIKE '%|23|%'
	ORDER BY `name` ASC
	LIMIT 0 , 30

should work, assuming you use MySQL.

nextgengames

Its coming up blank though :/ , Going to bring it to my local server for some testing and see what happens.