[SOLVED] Referencing multiple rows, non-unique data

[geudrik]

Alright, terrible title but I have no idea how to compress this into title form 

 

In my database, there are multiple rows, similar to:

 

Schoorasana VI - Moon 1 - CBD Corporation Storage

 

Now, all I have is a variable

$systemname

 

How do I look into my table and pull every row that has a solarsystem name of $solarsystem

 

In the first code block, Schoorasana is the solar system name, and every row with an SS is formatted in that way.

 

Anyone?

[ignace]

name LIKE '%$systemname%' will match any row that has $systemname in it's name

[geudrik]

Awesome, thanks Ignace

 

By the way, I love your signature. ++