How To Get table columns with some condition in MYSQL? [closed]


Problem :

Here is the situation like:

I am Having the table structure like the following:

--------------------------------------------------------------------------
  FieldName                  data_type
--------------------------------------------------------------------------   
surveyForm_1_id       varchar(255)
survey_form_id        varchar(255)
submitted_by          varchar(255)
submitted_on          varchar(255)   
field_name_1          varchar(255)
field_name_2          varchar(255)   
field_name_3          varchar(255)   
field_name_4          varchar(255)
field_name_5          varchar(255)   
field_name_6          varchar(255)   
field_name_7              varchar(255)

With Mysql Query i wanted to remove the following fiels from mytable..........

surveyForm_1_id 
survey_form_id  
submitted_by    
submitted_on 

For that I have Tried The Query as:

SHOW COLUMNS FROM surveyform_1

Anyone just suggest me...

I want the Query Which will give result fieldset as like

field_name_1     
field_name_2         
field_name_3         
field_name_4     
field_name_5         
field_name_6         
field_name_7


Solution :

Try this one:

SHOW COLUMNS FROM surveyform_1 WHERE Field LIKE 'field_name_%'

Mysql Tutorials

Mysql Howto..

How do I find records when data entry has been inconsistent?

mysql 'show create table' on several tables

how to generate ERD or UML for a database?

How to backup and restore in MySQL 5.2?

How to aggregate results from many rows into a single row mysql [duplicate]

how to select previous row based on date

How to put a literal “?” in a Mysql query with bind variables

How to avoid concurrent access to payment link in my website

How to batch load a CSV columns into a MySQL table

How to Prevent MySQL UUID V1 Collision

how to make mysql query like this situation?

How to make dump of all MySQL databases besides two

How to join this data in MySQL?

How to make a dropdown stay when processing different If/Else blocks?

How to load random content from MySql into div with JQuery onclick? [duplicate]

How to create a where query for Json in mysql with key having a white space in between the name

How to connect to a mysql database in C# and mimic the SELECT, UPDATE and INSERT functions

How to use data from a Webservice on Eclipse to populate a database in MySQL

DBGrid - how to show the differnce between a column value in two adjacent rows as another column?

MySQL Workbench: how to setup “ON UPDATE”? and CURRENT_TIMESTAMP?

How do i know how much space i need for mysql database

How do I add a column to an existing FULLTEXT index?

How to get nested json object with php mysql

How to pass MySQL database connection data in namevaluepairs from Android to PHP

how to fix correlated subquery on mysql

How to copy tables from one website to another with php?

How to select row count multiplied by non zero columns? (mysql)

How can I return an array/json object containing json objects through an ajax php call?

How to connect to mySql database on Web through Local Java App

MySQL: FULL OUTER JOIN - How do I merge one column?