02-14-2021, 10:14 AM
I am querying a MySQL table, and want it only to output items that match the word but can have other words as well. I am sort of looking for the equivalence of
in MySql.
![[Image: Screenshot-2021-02-14-at-11-02-41.png]](https://i.ibb.co/xJPskXx/Screenshot-2021-02-14-at-11-02-41.png)
Here is an image of my phpMyAdmin table. I am trying to search the table if the rightmost column, the `archetype` column. I am trying to find all results that match one word like Voltron, but the problem is that for example item #11, also has the word 'Keyword' in that column so it won't show.
![[Image: Screenshot-2021-02-14-at-11-02-46.png]](https://i.ibb.co/n1Xv05s/Screenshot-2021-02-14-at-11-02-46.png)
This is an example of what I want to search by. The last column, the archetype column is the variable. I want to query MySql for all items that were Archetype like Tribal, or like Voltron, but can contain other 'Archetypes' as well.
When I query by this card, item number 3,9,10,11, and 15 should be outputed.
And finally, this is what I have as the code, which right now doesn't work. $aType is an array with all of the Archetypes, and $arrayNum is a string with one of them. It all works, but I'm just curious if there is a way to find results that contain at least $arrayNum, but can contain more.
PHP Code:
strpos ( string $haystack , string $needle)
![[Image: Screenshot-2021-02-14-at-11-02-41.png]](https://i.ibb.co/xJPskXx/Screenshot-2021-02-14-at-11-02-41.png)
Here is an image of my phpMyAdmin table. I am trying to search the table if the rightmost column, the `archetype` column. I am trying to find all results that match one word like Voltron, but the problem is that for example item #11, also has the word 'Keyword' in that column so it won't show.
![[Image: Screenshot-2021-02-14-at-11-02-46.png]](https://i.ibb.co/n1Xv05s/Screenshot-2021-02-14-at-11-02-46.png)
This is an example of what I want to search by. The last column, the archetype column is the variable. I want to query MySql for all items that were Archetype like Tribal, or like Voltron, but can contain other 'Archetypes' as well.
When I query by this card, item number 3,9,10,11, and 15 should be outputed.
PHP Code:
$aType = $_GET['archetype'];
$aType = explode(" ", $aType);
$arrayNum = $aType[0];
foreach ($aType as $value){
//This Decides the Cards.
$query_all_items = mysqli_query($connect, "SELECT * FROM `edh__cardDatabase` WHERE `name` NOT LIKE '$name' AND `archetype` LIKE '$arrayNum' ORDER BY `name` ASC;");
$arrayNum = $aType[+1];
//This Decides the Cards.
while ($row = mysqli_fetch_array($query_all_items)) {
And finally, this is what I have as the code, which right now doesn't work. $aType is an array with all of the Archetypes, and $arrayNum is a string with one of them. It all works, but I'm just curious if there is a way to find results that contain at least $arrayNum, but can contain more.