# Php mysql SELECT

**URL:** <https://forum.kirupa.com/t/php-mysql-select/243104>\
**Category:** Uncategorized\
**Created:** [November 2, 2007, 8:09pm UTC](https://forum.kirupa.com/t/php-mysql-select/243104 "2007-11-02T20:09:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![owelowe](https://avatars.discourse-cdn.com/v4/letter/o/34f0e0/32.png) [@owelowe](https://forum.kirupa.com/u/owelowe)\
**Post date:** [November 2, 2007, 8:09pm UTC](https://forum.kirupa.com/t/php-mysql-select/243104/1 "2007-11-02T20:09:56Z")

</div>

I have a problem with extracting information from a mysql database, I want to search the database using a number like to, but in the database the rows can have several numbers like for example:

name jord  
first 234

```auto

SELECT * FROM database WHERE jord =2";

```

can I search the rows for individual numbers eventhou there are more than one number in the row?