Data from entire table displayed on a single search

Kevin M. Schafer · Post by **Kevin M. Schafer** » Tue 29 Nov 2011 18:14

Hi,

I'm using dbForge Studio for mySQL (30-day trial).

Is there something I need to "tick" (selection preference) when building my table within the Studio to allow only one line of data to appear in my results box? Or could this be an issue with my PHP search code?

I'm really getting the hang of this Studio and I like it. I built a table and imported about 40 lines, with five fields. When I enter a word, all 40 lines are returned in my search.

Thanks for any help you may have. I appreciate it.

alexa · Post by **alexa** » Thu 01 Dec 2011 10:15

Hello Kevin.

You can type SQL queries in SQL document (click 'New SQL' button on the Standard toolbar), execute them and get the result of the query in Data Editor where data can be sorted, filtered, grouped, modified, etc.
You can also perform the 'Retrieve Data' operation by selecting the corresponding item from the popup menu for a table in Database Explorer and the table data will be also displayed in Data Editor where you can perform various operations with data. Please refer to the 'Viewing Data in Grid' and 'Editing Data in Grid' topics in dbForge Studio for MySQL Help documentation for details.

Devart dbForge Studio for MySQL provides you the database object search functionality and the possibility of data search in tables and views. It is also possible to search for some text block in the database object DDL. Please refer to the 'Searching Database Objects' topic in Help documentation for details.